Key Lookup
Short Description
Key Lookup is a bookmark lookup in a table with a clustered index
Detailed Description​
Key Lookup is a bookmark lookup in a table with a clustered index. Key Lookup always has an associated NESTED LOOPS operator and this indicates it may benefit from some query tuning, possibly by the addition or a relevant index.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.